Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

customized region data type

Hi,   My organization uses custumized regions for management purposes. As an example we have one region called "Europe and Middle East" and "Asia Pacific". I need to create a map visualisation to s...
Need Help
  • Sean's avatar
    Sean
    9 years ago

    Anonymous

    You can't use the Legend and Color Saturation at the same time!

    Remove anything you have in the Color Saturation

    Place New Golder Region in the Legend and leave Region in Location and whatever you have in the Size

    Then click the Formating Paint Brush and this is where you can set the Data Colors

     

    The Table Next to my Map is the Matrix Preview Visual showing the new Cross-Highlighting feature

     

    This should work.

    Let me know if you have any questions.

    Good Luck! :smileyhappy:

     

Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
9 years ago

Anonymous

If you have a region column in your data just place it in the Legend of a Map.

 

 

 

If you don't how you proceed will depend on how many countries you have.

You could use a SWITCH statement (nested IFs) to assign the regions

Or you can create the Region column in the Query Editor - Add Column tab - Conditional Column

and use the User Interface to create it - again it would depend on how many countries you have.

Or you can use another table for this to obtain the region...

 

Hope this helps!